package com.dems.dao.mapper.la;

import com.dems.dao.dataobject.StaffRole;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface StaffRoleMapper {
    int deleteByPrimaryKey(Long id);

    int insert(StaffRole record);

    int insertSelective(StaffRole record);

    StaffRole selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(StaffRole record);

    int updateByPrimaryKey(StaffRole record);

    List<StaffRole> selectList(@Param("roleCode") String roleCode, @Param("workCity") String workCity);

    int insertBatch(@Param("staffRoleList") List<StaffRole> staffRoleList);

    List<StaffRole> selectByUserId(@Param("userId") String userId);

    List<StaffRole> selectByUserIdList(@Param("userIdList") List<String> userIdList);

    StaffRole selectByUserIdRoleCode(@Param("userId") String userId, @Param("roleCode") String roleCode);

    List<StaffRole> selectByRoleCode(@Param("roleCodeList") List<String> roleCodeList);

    List<Map<String, Object>> selectVCountList(@Param("userId") String userId, @Param("startDate") String startDate,
                                               @Param("endDate") String endDate, @Param("city") String city);

}